UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oO8E9Zkav02d18j2Y7Z8P2P9e9wcDzGB/3B92DuOv+c='
WHERE
key_id = 'fef2827d303d5b0aeeda31c9b9a535788a511d5cfa48016b5b6da4efc2fff790'
AND (
token = 'oO8E9Zkav02d18j2Y7Z8P2P9e9wcDzGB/3B92DuOv+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)