UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GJw8fAHba2xvq8/nsaJDVAOO+tsTGMGkv1zqQuOol4='
WHERE
key_id = 'f03d859beecad0dd6bd3ae3f88145860849a6d671303cb57df387a7a346f095d'
AND (
token = '6GJw8fAHba2xvq8/nsaJDVAOO+tsTGMGkv1zqQuOol4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)