UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VsfSMIlI8HXVwu5qQ0mFmEpSCqauV/IWSMADzfcPHd0='
WHERE
key_id = 'bb3e717164847606e067536df02be03017c9b0285f273f6642912a5215d79cc9'
AND (
token = 'VsfSMIlI8HXVwu5qQ0mFmEpSCqauV/IWSMADzfcPHd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)