UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uNrCDsm7i2bC6fOAcEATwjwgC3AEkD4WiNzncsil/L0='
WHERE
key_id = 'dddf1176820d4d7f65aca94150985d1a3aea10f124a08697af35111a0959d405'
AND (
token = 'uNrCDsm7i2bC6fOAcEATwjwgC3AEkD4WiNzncsil/L0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)