UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XX00NIIv+LSsk76CgDJ3r0XtLkffWQK+vCiNV8+J1ZY='
WHERE
key_id = '7f7e166f5dd93390108f23b80b77a8fc4930397a153645e70019ec265da00d59'
AND (
token = 'XX00NIIv+LSsk76CgDJ3r0XtLkffWQK+vCiNV8+J1ZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)