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