UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0rtb4lUk2DtfC8OCmHjWd611iBuyOD0pjhZmjapPFsU='
WHERE
key_id = 'f275e2730a16d725c854b925a8f897a36342506c589dfb9df973475c6922cac0'
AND (
token = '0rtb4lUk2DtfC8OCmHjWd611iBuyOD0pjhZmjapPFsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)