UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jas9mY+vYNmpD9iBFf5PnCeX8VjGpw1xwhTpO3E3Zbo='
WHERE
key_id = '4d23a73def3daef49eaed3aed295f9cd58b2a8a3a7d5acc3b2a2e8feaca7e8a3'
AND (
token = 'Jas9mY+vYNmpD9iBFf5PnCeX8VjGpw1xwhTpO3E3Zbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)