UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZRZGoKAaNT9LKFys+KeAcKnc/MHOPsZkuYv0ev9IKQ='
WHERE
key_id = '915f2b9b2ceec9f4e4d7072c7f9cb999bb60de47e7d0793447d220d6dfd0b9ab'
AND (
token = 'kZRZGoKAaNT9LKFys+KeAcKnc/MHOPsZkuYv0ev9IKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)