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