UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4QDFYDjVTnoWp+9BGAysmrqOq+otyI8RMCKSITK2LE='
WHERE
key_id = 'c5ee43c9fb384f4c18ac353b47f4b092f1f8909078c725411b1622f1a12906b9'
AND (
token = 'G4QDFYDjVTnoWp+9BGAysmrqOq+otyI8RMCKSITK2LE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)