UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4eKTjaf1ewD6GMXuADz9EUK1T7D+1O/XI1nQ9kPM1o='
WHERE
key_id = '47f548cf3e3153c9409c35035414d9cbd7969ad6782de88319903976e973a496'
AND (
token = 'C4eKTjaf1ewD6GMXuADz9EUK1T7D+1O/XI1nQ9kPM1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)