UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czx9sFfzhC7FrSF5pJuPHyGjONIw50ly0qlrZkbLXEg='
WHERE
key_id = '7b39d70e50091ae070373fb071715a85d0cf74c65a825763bd4aa0d1c0d50d14'
AND (
token = 'czx9sFfzhC7FrSF5pJuPHyGjONIw50ly0qlrZkbLXEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)