UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYVA74TN2EbDV0PdwOyYkh6vWGqmWrxQNJo+5A8GIIo='
WHERE
key_id = 'e7f1f827ad3cae55283a0fc90d975dc7f86ee5122be4d8ac2d282d58822ebe00'
AND (
token = 'pYVA74TN2EbDV0PdwOyYkh6vWGqmWrxQNJo+5A8GIIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)