UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pk6zlWvyhvhektVIZTk5ubOwaP5IrBFn3t8qZ9u8qeo='
WHERE
key_id = '92937b6617bc8a46d36ae9f195cb45b83d71277230faa9408d2975311395f056'
AND (
token = 'pk6zlWvyhvhektVIZTk5ubOwaP5IrBFn3t8qZ9u8qeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)