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