UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQcsjydiGPfdiLWRISRsRze6WPcaQlObZRiyQIjRhQ8='
WHERE
key_id = '8878d135356ffc1c69710dad6a01c6c7f0c2d14708e374edf1a43eede2308d21'
AND (
token = 'tQcsjydiGPfdiLWRISRsRze6WPcaQlObZRiyQIjRhQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)