UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ZbMfWleTCVdTzKMziAgAR8vnFNbrSB6uCZKyurN7V8='
WHERE
key_id = '408ec5e9f2bce6993b5afee141851e97f601af7e99b863a3fa33e320111b561d'
AND (
token = '4ZbMfWleTCVdTzKMziAgAR8vnFNbrSB6uCZKyurN7V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)