UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXr7Ad9gOkqsliTXlN3p2KhavPidZfQho0NUFWyZS5k='
WHERE
key_id = '307001250d12a01094d00f6bc8008d9187f34466faa0a8e945d9aa205ce8ae4d'
AND (
token = 'pXr7Ad9gOkqsliTXlN3p2KhavPidZfQho0NUFWyZS5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)