UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VbMHXmYlWq08pxb4iMHm9L4N6z0uH3C/xautlI+4d8k='
WHERE
key_id = 'abcd1ee3b9cb90dd5121d8c27cd1b8ec9d74129c47d132d2e40866ea71286d69'
AND (
token = 'VbMHXmYlWq08pxb4iMHm9L4N6z0uH3C/xautlI+4d8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)