UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pi79DT9zvsOD1qiDK15ug3T/2Gc2c0DeYjMCxMfNn6Q='
WHERE
key_id = 'e030215c58f3260adc4a907ae980935b2935cb28b9e45309c47084044773c5ed'
AND (
token = 'pi79DT9zvsOD1qiDK15ug3T/2Gc2c0DeYjMCxMfNn6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)