UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IiTZm43jbyIYyiIf1EXjdgzqj+/sFIXI++mvi+16PUU='
WHERE
key_id = 'be9b02383ab04fd01db0a2eaeccd6105909d8d70231f4e129824f83d3a11330d'
AND (
token = 'IiTZm43jbyIYyiIf1EXjdgzqj+/sFIXI++mvi+16PUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)