UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzs0abqNM5U2PSTSmU9L9sJCICYa5C0LTrUIiN5G8hw='
WHERE
key_id = '38dbeca4180485a47304c6c7ab157556e5a423c67a9a1faabafe53353f4e3aa2'
AND (
token = 'zzs0abqNM5U2PSTSmU9L9sJCICYa5C0LTrUIiN5G8hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)