UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCM//O5cznGD6OJNjs9bbn1iG96dsSdD2V/fD+aul1Y='
WHERE
key_id = '4a31c0538199fbbe822c1bf9cd45fd4f707e190f5449e6110ffea89055aaf1a3'
AND (
token = 'ZCM//O5cznGD6OJNjs9bbn1iG96dsSdD2V/fD+aul1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)