UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXHgX93gJAp57Bq7AyPxgOOG5NNHaWvA3H6pwsbjKD4='
WHERE
key_id = '12c0a78821b594635986b6299956e293d882e15d98dd93b049b1066c9d873c2f'
AND (
token = 'WXHgX93gJAp57Bq7AyPxgOOG5NNHaWvA3H6pwsbjKD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)