UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7z5nVrS2CnKu0Yh+MQgUgCZftCYdFcG5cEJz8/GmZc='
WHERE
key_id = 'aec5f13847a559a9bd29f7006a791f506c11964d2dd099485333e95081f5a0a2'
AND (
token = 'W7z5nVrS2CnKu0Yh+MQgUgCZftCYdFcG5cEJz8/GmZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)