UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9R4e0aJo8FORNVIZITEJqMtMyAZYTOtSHTQLM00VTk='
WHERE
key_id = 'a80200d95727040ca08fde86d47f9659b486e470cb5751223d5d55c810701c19'
AND (
token = 'B9R4e0aJo8FORNVIZITEJqMtMyAZYTOtSHTQLM00VTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)