UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VShmO3rx9OTffOegQztYPw4Ezb6ok6fQ/34duZ/C3sw='
WHERE
key_id = '1bf64db3682a5e827e6d4642bc1fc7f1ec432519f32765753e24aebee53e7f51'
AND (
token = 'VShmO3rx9OTffOegQztYPw4Ezb6ok6fQ/34duZ/C3sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)