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