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