UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aaPzdnJeeCEZdyWJGwHiI46FJd6CV2KSsRZgV9gRIz0='
WHERE
key_id = '787f19f4edba857acce8f3b18c38705e431ad0509f08f5161d74a7a4af0c47de'
AND (
token = 'aaPzdnJeeCEZdyWJGwHiI46FJd6CV2KSsRZgV9gRIz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)