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