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