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