UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9i2ciPXqKmgLAORlTJlC93Jcxz8j5/xJRY/Dezaj8D8='
WHERE
key_id = 'e390df3089f453e36a6f2c083bba194fe8fb7d889822ce89ad20ff6eb1a53b57'
AND (
token = '9i2ciPXqKmgLAORlTJlC93Jcxz8j5/xJRY/Dezaj8D8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)