UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YEfCKSPYG0/Y6oRYkz4w8mb6tLF4h/7Joam5fIN0/ao='
WHERE
key_id = '30166de18413a4ba9314be61f1ea68763c8a00d1dc9729d6bfce49d7189b62a2'
AND (
token = 'YEfCKSPYG0/Y6oRYkz4w8mb6tLF4h/7Joam5fIN0/ao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)