UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29zclyrrKdrF+peeUeBuKijLcDov0aRcd3aUm0IyA30='
WHERE
key_id = 'c0071870e3eed3ba77833ae3d71c111dce07c76f626c1ac9859e5e83c4bc01b0'
AND (
token = '29zclyrrKdrF+peeUeBuKijLcDov0aRcd3aUm0IyA30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)