UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBHC2trqkJoXSJXdSm2+Bc0jlMtyviU0aeYzOw67cvo='
WHERE
key_id = '5802a193ce78c35ae50c4871c97850c4ecf94c0697c681f58458c6d824fd5f73'
AND (
token = 'pBHC2trqkJoXSJXdSm2+Bc0jlMtyviU0aeYzOw67cvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)