UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csOCOJvW19i3IMCQzXnAbyFgGpydxyq9Mvw5Jvuq1gM='
WHERE
key_id = 'b3dae3b771c10f9b86b972707773fa5ea99c4e555648242e857ba4ff08b6c78c'
AND (
token = 'csOCOJvW19i3IMCQzXnAbyFgGpydxyq9Mvw5Jvuq1gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)