UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+f8MKgHZA0Zdx6L5nA4VwB7AXoQD03/O1E7Bt9btkg='
WHERE
key_id = 'c8c3a34ca2ef78b87ba9fa6192cf8ca8492312eaf2230c05027339534b305696'
AND (
token = '6+f8MKgHZA0Zdx6L5nA4VwB7AXoQD03/O1E7Bt9btkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)