UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R6zEztwiKcIa+YHQp4+T0o9hv9IEYlXF2xEgkLMKNGE='
WHERE
key_id = 'ca5c25d72c55c3e2d8c3507ca4300c871d61b53c8e1c8fc964f210f155f609c8'
AND (
token = 'R6zEztwiKcIa+YHQp4+T0o9hv9IEYlXF2xEgkLMKNGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)