UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhvy2+kh0kBgmRHNU9oj9dfdWkasSADozHaDdIqrEkU='
WHERE
key_id = 'd1b34fbc153a110801ddae438365a870ac1305d271783555a7213ebd09427771'
AND (
token = 'mhvy2+kh0kBgmRHNU9oj9dfdWkasSADozHaDdIqrEkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)