UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UMBgi/qrTiKmJCKwLuC/696tghl6q+i7N0KSJkMMMsU='
WHERE
key_id = '7b2b162ea34f491829c54a5dd57ed2a1858b5410d35c1109da71a616337930c6'
AND (
token = 'UMBgi/qrTiKmJCKwLuC/696tghl6q+i7N0KSJkMMMsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)